select * from products where pro_name like '%all%dresses%' or pro_des like '%all%dresses%'union all select * from products where (pro_name like '%all%' or pro_des like '%all%') or(pro_name like '%dresses%' or pro_des like '%dresses%') and (pro_name not like '%all%dresses%' or pro_des not like '%all%dresses%')
Turquoise Ball Gown Strapless Floor-length Organza Beading 16 Birthday Dresses
Baby Pink V-neck Front Straps Back Short 16 Birthday Party Dress
Lavender Sweetheart Beaded Chiffon Sash Short Dress For 16 Birthday Party Dress
Pink Ball Gown Strapless Floor-length Organza Beading 16 Birthday Party Dresses
Light Blue Ruffled Short sweetheart 16 Birthday Party Dress
Black Ball Gown Sweetheart Floor-length Sequined and Tulle Appliques 16 Birthday Party Dresses
Red Ball Gown One Shoulder Floor-length Organza Ruffles and Beading 16 Birthday Party Dresses
Purple Ball Gown Strapless Floor-length Organza Ruffles 16 Party Dresses
Elegant Ball Gown Ruffles Red 16 Birthday Party Dresses
Beaded Ruffles Layered Decorate 16 Birthday Party Dress With Sweetheart Aqua Skirt
Appliques and Pick-ups Wine Red Exquisite Style For 2013 16 Birthday Party Dress
Leopard and Organza Beading Decorate Sweetheart Neckline Exquisite 16 Birthday Party Dress
All Colors Ball Gown Strapless Appliques and Ruffles Sweet Sixteen Quinceanera Dresses
Modest Ball Gown Sweet Sixteen Quinceanera Dresses with Strapless Ruffles and Embroidery for 2014
2014 Ball Gown Strapless Appliques and Sahes Sweet 16 Dresses for Party
Ball Gown Strapless Organza Embroidery Sweet Sixteen Quinceanera Dresses
All Colors Sweetheart Quinceanera Dresses with Beading and Ruffles for 2014
All Colors Strapless Sweet Sweet 16 Dresses with Appliques and Ruffles for 2014 New
All Colors Ruffles Sweetheart Beading and Ruffles Dresses For a Quince in Sweet 16 Party
All Colors Discount Sweetheart Beading and Ruffles Sweet Sixteen Quinceanera Dresses
Colorful Sweetheart Quincenaera Dress For Graduation With Beaded Drcorate Ruffle Layers
Hot Pink Ball Gown Sweetheart Floor-length Organza Beading and Ruching Quinceanera Dresses
Aqua Blue Sweetheart Appliques and Beaded Decorate For 2013 Quinceanera Dress
Baby Pink Ruched Bodice Hand Made Flowers Decorate Waist For Quinceanera Dress
Appliques and Pick-ups Wine Red Brush Train Exquisite Style For 2013 Quinceanera Dress
New Style Sequins Spaghetti Straps 2015 Dama Dresses in Blue
Beautiful Ball Gown Strapless 2014 Quinceanera Dresses with Appliques
New Arrival Baby Blue Princesita With Quinceanera Dresses with Appliques and Ruffles
Fairy Two-Tier with Lace Angle Cut Edg Wedding Veils
Two-Tier Tulle Bridal Veils with Ribbon Edge